-
Re: How to prevent Smartsheet API from converting certain strings to integers
Hi @Lee Joramo @Lindsay Whitbread thanks for the replies So originally @Lee Joramo had the suggestion of just simply doing forcing the rowToAppend to be a string with the str() command to get str(row…2 · -
How to prevent Smartsheet API from converting certain strings to integers
Hi all, I am not sure if Smartsheet recently changed how strings and integers are formatted, but my API script has seemingly randomly began converting certain string values to integers automatically.…1 · -
Re: Formula for Moving Specific Columns from one sheet to another
Hi @Andrée Starå Yes I initially tried the VLOOKUP with the search value as the Entity Number(Unique column) from the bridge sheet and also the lookup table from the bridge sheet. It works when I ref…1 · -
Formula for Moving Specific Columns from one sheet to another
Hi Guys I have a few smartsheets that I'm working on. 1.Master Sheet 2.Construction Phase 3.Completion Phase All these have some specific same columns. The data will be initially entered in the Maste…1 ·